create table points (
id int(10) primary key not null auto_increment,
uid int(10) not null,
point bigint(20) not null,
money int(10) not null, 
residue int(10) not null)engine=innodb default charset=utf8"


				create trigger test before insert on point for each row
				begin
					set new.money = floor(new.point/1000);
					set new.residue = new.point%1000;
				end